﻿CREATE TABLE [dbo].[Finance_Subject] (
    [Id]          INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [SId]         UNIQUEIDENTIFIER CONSTRAINT [DF_Finance_Subject_SId] DEFAULT (newid()) ROWGUIDCOL NULL,
    [CateOneId]   INT              NULL,
    [CateTwoId]   INT              NULL,
    [ParentId]    INT              NULL,
    [ParentOldId] INT              CONSTRAINT [DF_Finance_Subject_ParentOldId] DEFAULT ((0)) NULL,
    [TypeId]      INT              NULL,
    [Sort]        INT              NULL,
    [Title]       NVARCHAR (50)    NULL,
    [Description] NVARCHAR (200)   NULL,
    [CreateDate]  DATETIME         CONSTRAINT [DF_Finance_Subject_CreateDate] DEFAULT (getdate()) NULL,
    CONSTRAINT [PK_Finance_Subject] PRIMARY KEY CLUSTERED ([Id] ASC)
);

